Released on = April 3, 2007, 4:36 pm

Press Release Author = Alba Spectrum Group

Industry = Computers

Press Release Summary = Microsoft Great Plains Dynamics GP is SQL driven application
and SQL scripting should be good support for Finance department in analyzing their
financial positions, especially when you have cash flow responsible subdivisions
within your company.

Press Release Body = Microsoft Great Plains Dynamics GP is SQL driven application
and SQL scripting should be good support for Finance department in analyzing their
financial positions, especially when you have cash flow responsible subdivisions
within your company. Similar job can be done in such tools as FRx, Crystal Reports,
however it is often too difficult to produce new FRx report, and it is too quick to
run select scripts against your GL. Plus SQL has advantage of joining GL with SOP,
POP, IV and produce aggregated queries for specific set of posted transactions. In
this small article we will show you how to produce Balance sheet for account
segment.

Let's assume you have subdivisions, each of them has individual second segment on
account. Following statement aggregates Debit-Credit summary for this segment (1001
in the sample below):

select
b.ACTNUMBR_1+ \' \'+ b.ACTNUMBR_2, sum(DEBITAMT) - sum (CRDTAMNT)
from
GL20000 a
join GL00100 b on a.ACTINDX

Web Site = http://www.albaspectrum.com

Contact Details = Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com
help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving GP clientele locally
in Chicago and Houston plus USA and Canada Nationwide via remote support: San
Francisco, Los Angeles, New Orleans, Miami, Orlando, Phoenix, Dallas, New York,
Denver, Seattle, Minneapolis, Montreal, Toronto, Vancouver, Atlanta, San Diego